Column and Row Expressions

Cube views accept calculated columns and rows using the GetDataCell function and references to cube view column and row names. This is known as Column/Row math.

Write column and row expressions in the cube view row or column itself. They calculate at runtime.

These expressions require a reference to the specific cube view column or row name to return a data point.

Use column and row expressions if you need to perform math across columns and rows. A common use case is with variance columns. Column and row expressions are useful if the query is more complex or if the expression is easy to understand and maintain.

NOTE: Use one of the other expression types if you are using multiple member expansions, especially when performing math on rows.